/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_time_segment.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_TIME_SEGMENT
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_time_segment.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_TIME_SEGMENT::CTable_PPM_TIME_SEGMENT( )
 :NPCRecordSet( )
{
  setTableName( "PPM_TIME_SEGMENT" );
  prepareTable();
  prepareQuery();
 
  TIME_SEGMENT_ID.setField( "TIME_SEGMENT_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( TIME_SEGMENT_ID );
  makeKeyItem( TIME_SEGMENT_ID ); 
  PROVISION_DATE.setField( "PROVISION_DATE", DATA_DATETIME, 14, 0 );
  makeTableItem( PROVISION_DATE );
  ACHIVE_DATE.setField( "ACHIVE_DATE", DATA_DATETIME, 14, 0 );
  makeTableItem( ACHIVE_DATE );
  ACHIVE_DATE_OFFSET_UNIT.setField( "ACHIVE_DATE_OFFSET_UNIT", DATA_DOUBLE, 22, 0 );
  makeTableItem( ACHIVE_DATE_OFFSET_UNIT );
  ACHIVE_DATE_OFFSET.setField( "ACHIVE_DATE_OFFSET", DATA_DOUBLE, 22, 0 );
  makeTableItem( ACHIVE_DATE_OFFSET );
  EFF_DATE.setField( "EFF_DATE", DATA_DATETIME, 14, 0 );
  makeTableItem( EFF_DATE );
  EXP_DATE.setField( "EXP_DATE", DATA_DATETIME, 14, 0 );
  makeTableItem( EXP_DATE );
  END_DATE_OFFSET_UNIT.setField( "END_DATE_OFFSET_UNIT", DATA_DOUBLE, 22, 0 );
  makeTableItem( END_DATE_OFFSET_UNIT );
  EFF_END_DATE_OFFSET.setField( "EFF_END_DATE_OFFSET", DATA_DOUBLE, 22, 0 );
  makeTableItem( EFF_END_DATE_OFFSET );
}


CTable_PPM_TIME_SEGMENT::CTable_PPM_TIME_SEGMENT( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_TIME_SEGMENT" );
  prepareTable();
  prepareQuery();
 
  TIME_SEGMENT_ID.setField( "TIME_SEGMENT_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( TIME_SEGMENT_ID );
  makeKeyItem( TIME_SEGMENT_ID ); 
  PROVISION_DATE.setField( "PROVISION_DATE", DATA_DATETIME, 14, 0 );
  makeTableItem( PROVISION_DATE );
  ACHIVE_DATE.setField( "ACHIVE_DATE", DATA_DATETIME, 14, 0 );
  makeTableItem( ACHIVE_DATE );
  ACHIVE_DATE_OFFSET_UNIT.setField( "ACHIVE_DATE_OFFSET_UNIT", DATA_DOUBLE, 22, 0 );
  makeTableItem( ACHIVE_DATE_OFFSET_UNIT );
  ACHIVE_DATE_OFFSET.setField( "ACHIVE_DATE_OFFSET", DATA_DOUBLE, 22, 0 );
  makeTableItem( ACHIVE_DATE_OFFSET );
  EFF_DATE.setField( "EFF_DATE", DATA_DATETIME, 14, 0 );
  makeTableItem( EFF_DATE );
  EXP_DATE.setField( "EXP_DATE", DATA_DATETIME, 14, 0 );
  makeTableItem( EXP_DATE );
  END_DATE_OFFSET_UNIT.setField( "END_DATE_OFFSET_UNIT", DATA_DOUBLE, 22, 0 );
  makeTableItem( END_DATE_OFFSET_UNIT );
  EFF_END_DATE_OFFSET.setField( "EFF_END_DATE_OFFSET", DATA_DOUBLE, 22, 0 );
  makeTableItem( EFF_END_DATE_OFFSET );
}

CTable_PPM_TIME_SEGMENT::~CTable_PPM_TIME_SEGMENT( )
{
    close();
}

